using System;
using System.Data;
using System.Collections.Generic;
namespace eTMS.DAO{
	/********************************BEGIN ChiPhiDaoTaoDAO****************************************/
	///<summary>
	/// <para>Author: Auto generated class by CSharp Code Generator v2.0</para>
	/// <para>Date:10/10/2011 04:04:12</para>
	/// <para>Class Name: ChiPhiDaoTaoDAO</para>
	/// <para>Description: Class access to table ChiPhiDaoTao in database. Class for coder code here</para>
	///</summary>

	
	public partial class ChiPhiDaoTaoDAO{
        public DataSet SelectAllDSWithKhoanTienByChuongTrinhDaoTao(int ChuongTrinhDaoTao_ID)
        {
            IDbCommand cmd = this.CreateCommand();
            cmd.CommandText = @"SELECT        KhoanTien.TenKhoanTien, ChiPhiDaoTao.ChiPhiDaoTao_ID, ChiPhiDaoTao.ChuongTrinhDaoTao_ID, ChiPhiDaoTao.NamThu, ChiPhiDaoTao.HocKy_ID, 
                                                         ChiPhiDaoTao.KhoanTien_ID, ChiPhiDaoTao.SoTien
                                FROM            ChiPhiDaoTao INNER JOIN
                                                         KhoanTien ON ChiPhiDaoTao.KhoanTien_ID = KhoanTien.KhoanTien_ID
                                WHERE ChuongTrinhDaoTao_ID=" + ChuongTrinhDaoTao_ID.ToString();
            return this.SelectDS(cmd);

        }

	}
	/*****************************************************************************************************/
	/**********************************END ChiPhiDaoTaoDAO*****************************************/
	/*****************************************************************************************************/
}

